SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbProveedores
AS
SELECT     dbo.tb_Proveedores.RazonSocial, dbo.vwelocalidades.localidad AS Localidad, dbo.tb_Proveedores.CUIT
FROM         dbo.tb_Proveedores INNER JOIN
                      dbo.vwelocalidades ON dbo.tb_Proveedores.Localidad = dbo.vwelocalidades.ID
GO
GRANT SELECT ON  [dbo].[vwbProveedores] TO [AdministracionEscolar]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionComprasySuministros]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionContable]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionDeposito]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionInventario]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionServiciosEscolares]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [GestionSubsidiosyRendiciones]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbProveedores] TO [SoloVer]
GO
